Text copied to clipboard!
Title
Text copied to clipboard!PHP LMS Monolith Query Optimizer
Description
Text copied to clipboard!
We are looking for a PHP LMS Monolith Query Optimizer to join our development team and help improve the performance and scalability of our Learning Management System (LMS). This role is ideal for someone with deep experience in PHP, SQL query optimization, and monolithic system architecture. You will be responsible for analyzing, profiling, and optimizing complex database queries within a large-scale PHP-based LMS application.
As a Query Optimizer, you will work closely with backend developers, database administrators, and DevOps engineers to identify performance bottlenecks and implement solutions that enhance system responsiveness and reliability. You will also contribute to the development of best practices for query design, indexing strategies, and data access patterns.
The ideal candidate has a strong background in PHP development, a deep understanding of relational databases (especially MySQL or PostgreSQL), and experience working with large monolithic codebases. You should be comfortable using profiling tools, analyzing execution plans, and refactoring legacy code to improve performance.
This is a highly technical role that requires attention to detail, analytical thinking, and a passion for performance optimization. You will have the opportunity to make a significant impact on the user experience of thousands of learners and educators who rely on our LMS platform daily.
If you are passionate about clean, efficient code and enjoy solving complex performance challenges, we encourage you to apply.
Responsibilities
Text copied to clipboard!- Analyze and optimize SQL queries in a PHP-based LMS monolith
- Collaborate with developers to refactor inefficient data access patterns
- Use profiling tools to identify performance bottlenecks
- Design and implement indexing strategies
- Review and improve database schema for performance
- Document optimization strategies and best practices
- Monitor system performance and suggest improvements
- Work with DevOps to ensure optimized deployment configurations
- Participate in code reviews with a focus on performance
- Stay updated on latest PHP and database optimization techniques
Requirements
Text copied to clipboard!- 5+ years of experience in PHP development
- Strong knowledge of SQL and relational databases (MySQL/PostgreSQL)
- Experience with query profiling and optimization tools
- Familiarity with monolithic application architecture
- Ability to read and refactor legacy code
- Understanding of indexing, normalization, and denormalization
- Experience with performance monitoring tools
- Excellent problem-solving and analytical skills
- Strong communication and collaboration abilities
- Bachelor’s degree in Computer Science or related field
Potential interview questions
Text copied to clipboard!- Describe your experience optimizing SQL queries in PHP applications.
- What tools do you use for profiling and performance analysis?
- How do you approach refactoring legacy code for better performance?
- Can you explain a time you significantly improved system performance?
- What indexing strategies have you implemented in past projects?
- How do you ensure your optimizations are scalable?
- What challenges have you faced working with monolithic systems?
- How do you stay current with PHP and database optimization trends?
- What is your process for identifying performance bottlenecks?
- Have you worked with any LMS platforms before?
